<!--#include file="lib/utf-8.asp"-->
<!--#include file="lib/connopen.asp"-->
<!--#include file="lib/asp-common-lib.asp"-->
<%if CheckEmployee() then%>
<table id="cd" class="full">
    <thead>
        <tr><th colspan="12" scope="col">今日报关单变动情况表</th></tr>
    </thead>
    <tbody>
        <tr>
            <th scope="col">报关单号</th>
            <th scope="col">委托人</th>
            <th scope="col">被委托人</th>
            <th scope="col">类型</th>
            <th scope="col">申报日期</th>
            <th scope="col">企业名称</th>
            <th scope="col">船名/航次</th>
            <th scope="col">提单号</th>
            <th scope="col">核销单号</th>
            <th scope="col">更新时间</th>
            <th scope="col">岗位</th>
            <th scope="col">备注</th>
        </tr>
        <%
        Set rs_new = Server.CreateObject("ADODB.Recordset")
        ' sql = "SELECT * FROM cdfee where username=1 and DateValue(cd_update)=date() order by cd_update desc"
        sql = "SELECT * FROM cdfee where id in (select re_id from record where re_table='cd' and DateValue(re_update)=date() and username="&session("iId")&") order by cd_update desc"
        rs_new.Open sql,conn,1,1
        do while not rs_new.eof
        %>
        <tr>
            <th class="sub" scope="row"><a href="process.asp?id=<%=rs_new("id")%>"><%=right(rs_new("cd_no"),9)%></a></th>
            <td><%=rs_new("wtr_name")%></td>
            <td><%=rs_new("bwtr_name")%></td>
            <td><%=rs_new("category_name")%></td>
            <td><%=rs_new("cd_date")%></td>
            <td><%=rs_new("cd_company")%></td>
            <td><%=rs_new("cd_voyage")%></td>
            <td><%=rs_new("cd_lading")%></td>
            <td><%=rs_new("cd_verify")%></td>
            <td><%=rs_new("cd_update")%></td>
            <td><%=GetPostString(session("aaPostName"),rs_new("cd_post"))%></td>
            <td><%=rs_new("cd_memo")%></td>
        </tr>
        <%
          rs_new.movenext
        loop
        rs_new.close
        set rs_new=nothing
        %>
    </tbody>
</table>
<%end if%>

<!--#include file="lib/connclose.asp"-->

